package top.itlir.edc.dao;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import top.itlir.edc.domain.SubArea;

public interface SubareaRepository extends JpaRepository<SubArea, String> {

	@Query("select a.district, count(*)  from SubArea s inner join s.area a group by a.district")
	List<Object> showChart();

}
